www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/khhj.cpp
// khhj.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "khhj.h" #include "xkh.h" #include "ado.h" #include "xlxr.h" #include "lxrxx.h" #include "qlxr.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif //ado rsthj; CString bgdh; ///////////////////////////////////////////////////////////////////////////// // khhj dialog khhj::khhj(CWnd* pParent /*=NULL*/) : CDialog(khhj::IDD, pParent) { //{{AFX_DATA_INIT(khhj) // NOTE: the ClassWizard will add member initialization here //}}AFX_DATA_INIT } void khhj::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(khhj) DDX_Control(pDX, IDC_EDIT9, m_edit9); DDX_Control(pDX, IDC_EDIT8, m_edit8); DDX_Control(pDX, IDC_EDIT7, m_edit7); DDX_Control(pDX, IDC_EDIT6, m_edit6); DDX_Control(pDX, IDC_EDIT5, m_edit5); DDX_Control(pDX, IDC_EDIT4, m_edit4); DDX_Control(pDX, IDC_EDIT3, m_edit3); DDX_Control(pDX, IDC_EDIT2, m_edit2); DDX_Control(pDX, IDC_EDIT10, m_edit10); DDX_Control(pDX, IDC_EDIT1, m_edit1); DDX_Control(pDX, IDC_COMBO1, m_com1); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(khhj, CDialog) //{{AFX_MSG_MAP(khhj) ON_BN_CLICKED(IDC_BUTTON4, OnButton4) ON_BN_CLICKED(IDC_BUTTON5, OnButton5) ON_BN_CLICKED(IDC_BUTTON2, OnButton2) ON_BN_CLICKED(IDC_BUTTON3, OnButton3) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // khhj message handlers BOOL khhj::OnInitDialog() { CDialog::OnInitDialog(); ado rst; rst.Open("select * from tb_khxx",adCmdText); int count=rst.GetRecordCount(); int i; for(i=1;i<=count;i++) { this->m_com1.AddString(rst.GetFieldValue("khxx_gsdh")); rst.Move(i); } this->m_edit1.EnableWindow(false); this->m_edit2.EnableWindow(false); this->m_edit3.EnableWindow(false); this->m_edit4.EnableWindow(false); this->m_edit5.EnableWindow(false); this->m_edit6.EnableWindow(false); this->m_edit7.EnableWindow(false); this->m_edit8.EnableWindow(false); this->m_edit9.EnableWindow(false); this->m_edit10.EnableWindow(false); rst.close(); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void khhj::OnButton4() { this->EndDialog(true); } void khhj::texttowin() { this->m_edit1.SetWindowText(edit1); this->m_edit2.SetWindowText(edit2); this->m_edit3.SetWindowText(edit3); this->m_edit4.SetWindowText(edit4); this->m_edit5.SetWindowText(edit5); this->m_edit6.SetWindowText(edit6); this->m_edit7.SetWindowText(edit7); this->m_edit8.SetWindowText(edit8); this->m_edit9.SetWindowText(edit9); this->m_edit10.SetWindowText(edit10); } void khhj::datatotext() { } void khhj::OnButton5() { ado rst1; this->m_com1.GetWindowText(bgdh); if(bgdh.IsEmpty()) {return;} CString sql; sql.Format("select * from tb_khxx where khxx_gsdh='%s'",bgdh); rst1.Open(sql,adCmdText); edit1=rst1.GetFieldValue("khxx_id"); edit2=rst1.GetFieldValue("khxx_qydz"); edit3=rst1.GetFieldValue("khxx_frdb"); edit4=rst1.GetFieldValue("khxx_yhzh"); edit5=rst1.GetFieldValue("khxx_lxr"); edit6=rst1.GetFieldValue("khxx_lxrdh"); edit7=rst1.GetFieldValue("khxx_mc"); edit8=rst1.GetFieldValue("khxx_khyh"); edit9=rst1.GetFieldValue("khxx_nsh"); edit10=rst1.GetFieldValue("khxx_ICcard"); this->texttowin(); rst1.close(); } void khhj::OnButton2() { CString ss,sid; this->m_edit1.GetWindowText(sid); if(sid.IsEmpty()) {return;} xkh k; ado rst; ss.Format("select * from tb_khxx where khxx_id='%s'",sid); rst.rstOpen(ss); k.edit1=rst.GetFieldValue("khxx_id"); k.edit8=rst.GetFieldValue("khxx_mc"); k.com1=rst.GetFieldValue("khxx_qyxz"); k.com2=rst.GetFieldValue("khxx_qylx"); k.com5=rst.GetFieldValue("khxx_qyzx"); k.edit2=rst.GetFieldValue("khxx_qydz"); k.com3=rst.GetFieldValue("khxx_szsf"); k.edit9=rst.GetFieldValue("khxx_szcs"); k.edit3=rst.GetFieldValue("khxx_gsyb"); k.edit10=rst.GetFieldValue("khxx_frdb"); k.edit12=rst.GetFieldValue("khxx_khyh"); k.edit4=rst.GetFieldValue("khxx_yhzh"); k.edit11=rst.GetFieldValue("khxx_nsh"); k.edit13=rst.GetFieldValue("khxx_ICcard"); k.edit5=rst.GetFieldValue("khxx_gswz"); k.edit14=rst.GetFieldValue("khxx_gsdh"); k.edit6=rst.GetFieldValue("khxx_gscz"); k.edit15=rst.GetFieldValue("khxx_lxr"); k.edit7=rst.GetFieldValue("khxx_lxrdh"); k.com4=rst.GetFieldValue("khxx_khjb"); k.edit16=rst.GetFieldValue("khxx_bz"); rst.close(); k.DoModal(); } void khhj::OnButton3() { /* CString ss2,sname; this->m_edit5.GetWindowText(sname); if(sname.IsEmpty()) {return;} xlxr l; ado rst2; ss2.Format("select * from tb_Client_lxrxx where lxrxx_xm='%s'",sname); rst2.rstOpen(ss2); l.edit1=rst2.GetFieldValue("lxrxx_id"); l.com1=rst2.GetFieldValue("lxrxx_qymc"); l.edit2=rst2.GetFieldValue("lxrxx_xm"); l.com2=rst2.GetFieldValue("lxrxx_xb"); l.edit3=rst2.GetFieldValue("lxrxx_nl"); l.com3=rst2.GetFieldValue("lxrxx_zw"); l.edit4=rst2.GetFieldValue("lxrxx_bgdh"); l.edit5=rst2.GetFieldValue("lxrxx_Email"); l.edit6=rst2.GetFieldValue("lxrxx_sj"); l.date1=rst2.GetFieldValue("lxrxx_csny"); l.edit7=rst2.GetFieldValue("lxrxx_grjj"); l.date2=rst2.GetFieldValue("lxrxx_djrq"); l.edit8=rst2.GetFieldValue("lxrxx_xxdjr"); l.edit9=rst2.GetFieldValue("lxrxx_bz"); rst2.close(); l.DoModal(); */ qlxr l; l.DoModal(); }